﻿<?xml version="1.0" encoding="UTF-8" ?>
<sqlMap namespace="ibatisnet" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <statements>
    <select id="ProcessCategoryLogic_GetList" resultClass="Workflow.Entity.ProcessCategoryEntity" >
      SELECT DISTINCT CATEGORYNAME,CATEGORYENNAME,ORDERNO FROM V_CATEGORY ORDER BY ORDERNO
    </select>

    <select id="ProcessCategoryLogic_GetProcessList" resultClass="Workflow.Entity.ProcessEntity" >
      SELECT * FROM V_CATEGORY WHERE 1=1
      <dynamic prepend="AND">
        <isParameterPresent>
          CATEGORYNAME=#CATEGORYNAME# or CATEGORYENNAME=#CATEGORYNAME#
        </isParameterPresent>
      </dynamic>

    </select>

  </statements>
</sqlMap>